/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.9
 Source Server Type    : MySQL
 Source Server Version : 50738 (5.7.38)
 Source Host           : 192.168.1.9:13306
 Source Schema         : zrkj_dsc

 Target Server Type    : MySQL
 Target Server Version : 50738 (5.7.38)
 File Encoding         : 65001

 Date: 23/11/2023 09:21:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_algorithm
-- ----------------------------
DROP TABLE IF EXISTS `sys_algorithm`;
CREATE TABLE `sys_algorithm` (
  `id` varchar(64) COLLATE utf8mb4_estonian_ci NOT NULL,
  `sfid` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '算法id',
  `sfmc` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '算法名称',
  `jcfw` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '检测范围',
  `zjjcbc` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '增加检测步长',
  `lsxsdlsh` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '路上行使电量损耗参数',
  `cddddlshcs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '充电等待电量损耗参数',
  `sjzsjgcs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '时间折算成价格参数',
  `sflx` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '算法类型',
  `yhsjhdxs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户时间花费系数',
  `cdzlylxs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '充电桩利用率系数',
  `dwjhdxs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '电网均衡度系数',
  `mxddgxsc` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '模型等待更新时长',
  `dqclfw` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '调取车辆范围',
  `socpdyz` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT 'SOC判断阈值',
  `cdclslqw` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '充电车辆数量期望',
  `mbyhqwcs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '目标用户期望参数',
  `column17` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column18` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column19` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column20` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column21` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column22` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column23` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column24` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column25` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column26` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column27` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column28` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column29` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column30` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_estonian_ci COMMENT='算法表';

-- ----------------------------
-- Records of sys_algorithm
-- ----------------------------
BEGIN;
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797258957225986', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797269291991041', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797273763119105', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797275088519169', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797275910602754', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797276686548994', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797277433135106', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797278150361089', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797278850809858', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797279551258626', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797280226541570', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797281006682113', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797281702936577', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797282449522690', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797283141582849', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797284110467073', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797284752195585', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797285549113345', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797286362808321', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797287205863425', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797288086667265', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797288959082498', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797289927966721', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797290758438914', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797291551162370', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797292373245953', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797293178552321', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797293879001090', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797294684307458', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797296232005634', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797296986980354', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797297695817730', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797298547261441', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797299352567810', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797300048822274', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797300787019778', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797301651046402', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797302410215426', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797303211327489', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797304020828161', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797304721276929', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797305497223169', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797307036532738', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797307837644801', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797308630368257', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797309351788546', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797310085791745', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797310933041154', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797311704793090', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797312472350721', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797313214742530', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797314020048898', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797314712109057', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797315513221122', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797316272390145', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797317002199041', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797317916557314', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797318642171906', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797319464255490', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797320152121345', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797320928067585', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797321766928386', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797322500931585', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797323243323394', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_algorithm` (`id`, `sfid`, `sfmc`, `jcfw`, `zjjcbc`, `lsxsdlsh`, `cddddlshcs`, `sjzsjgcs`, `sflx`, `yhsjhdxs`, `cdzlylxs`, `dwjhdxs`, `mxddgxsc`, `dqclfw`, `socpdyz`, `cdclslqw`, `mbyhqwcs`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1726797323906023425', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
COMMIT;

-- ----------------------------
-- Table structure for sys_marketing
-- ----------------------------
DROP TABLE IF EXISTS `sys_marketing`;
CREATE TABLE `sys_marketing` (
  `id` varchar(64) COLLATE utf8mb4_estonian_ci NOT NULL,
  `yxhdid` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '营销活动编号',
  `yxhdm` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '营销活动名',
  `yxfs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '营销方式',
  `sl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '数量',
  `psmb` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '派送目标',
  `yxq` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '有效期',
  `hdkssj` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '活动开始时间',
  `famc` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '方案名称',
  `fabh` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '方案编号',
  `gs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '概述',
  `cjr` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '创建人',
  `shzt` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '审核状态',
  `hksf` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '获客算法',
  `tgdxzcrs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '通过短信注册人数',
  `yfsdxsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '已发送短信数量',
  `cddxsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '触达短信数量',
  `dzrs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '到站人数',
  `ffyhj` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '发放/使用优惠卷/份',
  `dzljcdl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '到站累积充电量',
  `dzljcdje` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '到站累积充电金额',
  `column21` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column22` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column23` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column24` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column25` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column26` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column27` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column28` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column29` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column30` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_estonian_ci COMMENT='营销活动表';

-- ----------------------------
-- Records of sys_marketing
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_soc
-- ----------------------------
DROP TABLE IF EXISTS `sys_soc`;
CREATE TABLE `sys_soc` (
  `id` varchar(64) COLLATE utf8mb4_estonian_ci NOT NULL,
  `cllx` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '车辆类型',
  `yhlx` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户类型',
  `column16` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column17` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column18` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column19` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column20` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column21` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column22` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column23` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column24` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column25` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column26` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column27` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column28` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column29` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column30` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_estonian_ci COMMENT='首页-soc';

-- ----------------------------
-- Records of sys_soc
-- ----------------------------
BEGIN;
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1', '租车', '刚需用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('10', '网约车', '刚需用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('101', '私家车', '刚需用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1011', '物流车', '刚需用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('11', '租车', '刚需用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1111', '私家车', '刚需用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('111111', '私家车', '潜在用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1111211111', '物流车', '潜在用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('11121111', '物流车', '刚需用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('112', '租车', '潜在用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1121', '网约车', '刚需用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('11211', '私家车', '潜在用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1121111', '私家车', '刚需用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1122', '网约车', '潜在用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1221', '物流车', '潜在用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1321', '物流车', '非目标用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('2', '租车', '潜在用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('22', '网约车', '潜在用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('221', '私家车', '潜在用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('3', '租车', '非目标用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('32', '网约车', '非目标用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_soc` (`id`, `cllx`, `yhlx`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('321', '私家车', '非目标用户', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_station
-- ----------------------------
DROP TABLE IF EXISTS `sys_station`;
CREATE TABLE `sys_station` (
  `id` varchar(64) COLLATE utf8mb4_estonian_ci NOT NULL,
  `czbh` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '场站编号',
  `czm` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '场站名',
  `cdzlyl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '充电桩利用率',
  `sstqfzsp` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '所属台区负载水平',
  `pjpdsc` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '平均排队时长',
  `cdsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '充电数量',
  `fwl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '服务类',
  `yyzt` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '应用状态',
  `yxhdid` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '营销活动ID',
  `yfwf` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '原服务费',
  `tjfwf` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '推荐服务费',
  `qy` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '区域',
  `clpddhsj` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '车辆排队等侯时间',
  `cdzsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '充电桩数量',
  `kczsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '快充充电桩数量',
  `zxkczsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '在线快充充电桩数量',
  `mczsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '慢充充电桩数量',
  `zxmczsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '在线慢充充电桩数量',
  `column20` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column21` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column22` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column23` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column24` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column25` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column26` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column27` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column28` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column29` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column30` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_estonian_ci COMMENT='场所表';

-- ----------------------------
-- Records of sys_station
-- ----------------------------
BEGIN;
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134850487672833', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134855525031938', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134857404080129', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134858280689666', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134858993721345', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134859627061250', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134860356870146', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134861162176514', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134861854236674', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134862537908225', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134863347408897', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134864173686786', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134864890912769', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134865599750146', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134866413445121', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727134867164225538', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727135863122628609', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727136023068164097', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727136382272544770', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727136583087439874', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727136695524143105', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727136818295640066', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727136820770279425', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
INSERT INTO `sys_station` (`id`, `czbh`, `czm`, `cdzlyl`, `sstqfzsp`, `pjpdsc`, `cdsl`, `fwl`, `yyzt`, `yxhdid`, `yfwf`, `tjfwf`, `qy`, `clpddhsj`, `cdzsl`, `kczsl`, `zxkczsl`, `mczsl`, `zxmczsl`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1727137455876063234', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string');
COMMIT;

-- ----------------------------
-- Table structure for sys_xfxy
-- ----------------------------
DROP TABLE IF EXISTS `sys_xfxy`;
CREATE TABLE `sys_xfxy` (
  `id` varchar(64) COLLATE utf8mb4_estonian_ci NOT NULL,
  `sjly` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '数据来源',
  `tkz` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '调控值',
  `dqfw` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '地区范围',
  `zxz` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '执行值',
  `xyl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '相应率',
  `btje` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '补贴金额',
  `time` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '时间',
  `column21` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column22` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column23` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column24` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column25` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column26` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column27` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column28` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column29` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column30` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_estonian_ci COMMENT='削封响应表';

-- ----------------------------
-- Records of sys_xfxy
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_yssjb
-- ----------------------------
DROP TABLE IF EXISTS `sys_yssjb`;
CREATE TABLE `sys_yssjb` (
  `id` varchar(64) COLLATE utf8mb4_estonian_ci NOT NULL,
  `time` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '时间',
  `ddsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '订单数量',
  `sr` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '收入',
  `yhsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户数量',
  `fh` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '负荷',
  `fwf` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '服务费',
  `stationid` varchar(255) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '站电id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_estonian_ci COMMENT='运营数据表';

-- ----------------------------
-- Records of sys_yssjb
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_zrus
-- ----------------------------
DROP TABLE IF EXISTS `sys_zrus`;
CREATE TABLE `sys_zrus` (
  `id` varchar(64) COLLATE utf8mb4_estonian_ci NOT NULL,
  `uid` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户id',
  `uname` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户名',
  `upasswd` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户密码',
  `uy` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '密码盐',
  `cjsj` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '创建时间',
  `sjh` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '手机号',
  `fwcs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '服务次数',
  `yhzt` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户状态',
  `yhlx` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户类型',
  `dxfssj` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '短信发送时间',
  `sfcd` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '是否触达',
  `yxfs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '营销方式',
  `syqk` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '使用情况',
  `sfysz` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '是否有私桩',
  `sfysjc` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '是否有私家车',
  `sjcsl` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '私家车数量',
  `column17` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column18` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column19` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column20` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column21` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column22` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column23` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column24` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column25` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column26` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column27` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column28` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column29` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column30` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_estonian_ci COMMENT='用户表';

-- ----------------------------
-- Records of sys_zrus
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_zruser
-- ----------------------------
DROP TABLE IF EXISTS `sys_zruser`;
CREATE TABLE `sys_zruser` (
  `id` varchar(64) COLLATE utf8mb4_estonian_ci NOT NULL,
  `uid` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户id',
  `uname` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户名',
  `upasswd` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户密码',
  `uy` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '密码盐',
  `cjsj` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '创建时间',
  `sjh` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '手机号',
  `fwcs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '服务次数',
  `yhzt` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户状态',
  `yhlx` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '用户类型',
  `dxfssj` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '短信发送时间',
  `sfcd` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '是否触达',
  `yxfs` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '营销方式',
  `syqk` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL COMMENT '使用情况',
  `column14` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column15` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column16` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column17` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column18` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column19` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column20` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column21` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column22` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column23` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column24` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column25` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column26` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column27` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column28` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column29` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `column30` varchar(128) COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_estonian_ci COMMENT='用户表';

-- ----------------------------
-- Records of sys_zruser
-- ----------------------------
BEGIN;
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('1', '103', 'admin', '黄斌', '00', 'binhuan@live.cn', '15851862044', '0', 'http://127.0.0.1:9300/statics/2022/08/06/blob_20220806003741A001.jpeg', '$2a$10$zQHMx.pJoNVkbLfZaah6/e8QIs.5c75LrkeLnZrpHChRNhi2atGdS', '0', '0', '127.0.0.1', '2022-06-15 07:36:55', '0.0.0.0', NULL, NULL, '47322bb376886c2fe5db146a7f3650f1020a297a92fea7486387014c328afa71', 'admin', '2022-06-15 07:36:55', '', '2023-05-04 15:29:33', '管理员', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('10', NULL, 'sysUser', '系统管理员', '00', '', '', '0', '', '$2a$10$9zdLC6pd8bSfpFse0wDbYe0Teq4mvQB8oQlN3zOnivjdIlM8kzwK.', '0', '0', '', NULL, '0.0.0.0', '2023-07-12 22:47:09', '2023-04-13 22:47:09', '3245ae903cece33af13eb666b7ba8692f14cb2cbc08a1112f0eeb9ce3472cd14', 'admin', '2023-02-17 15:16:24', 'admin', '2023-05-04 15:29:33', NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('11', '107', 'ywUser', '运维', '00', '', '', '0', '', '$2a$10$F3kYFVZvupZnEDoqh0brZOhcfUkIhWJNdMuq20xtP6bG7SFRXenjy', '0', '0', '', NULL, '0.0.0.0', '2024-01-22 10:17:40', '2023-10-24 10:17:40', '0a742b8ed7e289f2e57280cff5b399eab17aba5bfc69eddbefc8581a65bb0c82', 'admin', '2023-02-17 15:28:17', 'sysUser', '2023-10-24 10:17:40', NULL, NULL, '0', NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('111', '103', 'admin', '黄斌', '00', 'binhuan@live.cn', '15851862044', '0', 'http://127.0.0.1:9300/statics/2022/08/06/blob_20220806003741A001.jpeg', '$2a$10$zQHMx.pJoNVkbLfZaah6/e8QIs.5c75LrkeLnZrpHChRNhi2atGdS', '0', '0', '127.0.0.1', '2022-06-15 07:36:55', '0.0.0.0', NULL, NULL, '47322bb376886c2fe5db146a7f3650f1020a297a92fea7486387014c328afa71', 'admin', '2022-06-15 07:36:55', '', '2023-05-04 15:29:33', '管理员', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('2', '105', 'ry', '若依', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$Lv6H6D7PqN0puAubgz1ZleeN.pIbjU2WNMN/U4Qb2eDCZHIrfGC1y', '0', '2', '127.0.0.1', '2022-06-15 07:36:55', '0.0.0.0', '2023-03-30 00:00:00', NULL, 'e4042b7b6ec8d84f5221bf37f7c4e45a1d53d4d74850936532e72b23c2860f59', 'admin', '2022-06-15 07:36:55', 'admin', '2023-03-13 14:27:47', '测试员', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('25', NULL, 'comUser', '普通用户', '00', '', '', '0', '', '$2a$10$5vtk3WNkl4z0RgfxXI7l1.VN..g1KKHotltKSqC6ItDk4Agv1aY2i', '0', '0', '', NULL, '0.0.0.0', '2023-10-31 00:00:00', NULL, 'aae8e5c80e266a07eea7073a73546d536b46687dadaed003af62d92c27aff64a', 'admin', '2023-02-23 09:25:52', 'sysUser', '2023-05-04 15:29:33', NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('27', NULL, 'ceshi', '测试', '00', '', '', '0', '', '$2a$10$7Hryk4yFD4r818QgZodo4.LXq2akHWcUIK19We5aD3mF9dAAtFS7i', '0', '2', '', NULL, '0.0.0.0', '2023-06-23 00:00:00', NULL, 'ebab020904272850404814327e52f3969fb1f49d2f18101ec8255c7f3250195e', 'admin', '2023-03-13 16:42:05', 'admin', '2023-03-14 10:10:07', NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('29', '100', 'ceshiUser', '测试用户新增', '00', '', '', '0', '', '$2a$10$i.O8p06uM/kUeBvmQ9zDaunPeNieYNqO/TrtzQcebQqz8nB6GHsom', '0', '2', '', NULL, '0.0.0.0', '2023-03-30 00:00:00', NULL, 'ccc090052a96b982e94580e98f829907633a64a9696e639ec825f2efda6d1c4f', 'sysUser', '2023-03-24 13:12:45', '', '2023-03-24 13:12:45', NULL, NULL, '1', NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('3', '103', 'alvin', '黄斌', '00', 'binhuang@live.cn', '13770961370', '0', '', '$2a$10$Lv6H6D7PqN0puAubgz1ZleeN.pIbjU2WNMN/U4Qb2eDCZHIrfGC1y', '0', '2', '', NULL, '0.0.0.0', NULL, NULL, '5980e9867a2bcefdaf89691301f69d44635ff0eb9920dca98dc68b804c2b1450', 'admin', '2022-07-09 13:27:07', 'admin', '2023-02-18 16:58:12', NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('31', '100', 'ceUser', '测试用户', '00', '', '', '0', '', '$2a$10$NEp/k5G58QraeByC9tGuvuI6RTXgHcIFlzfkYUSaEI5c9HTR4lAM6', '0', '2', '', NULL, '0.0.0.0', '2023-03-31 00:00:00', NULL, '92675427824f1eae68f19538648ea8013e2f3f26fc4e2b777a9e7106fa0d9b19', 'sysUser', '2023-03-24 13:14:05', '', '2023-03-24 13:14:05', NULL, NULL, '0', NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('32', NULL, 'audit', '审计', '00', '', '', '0', '', '$2a$10$B6og1ihkuNFv3sexq0xjkOwsA.bSHttlQWyvCzGCDAcPamxfkbgmy', '0', '0', '', NULL, '0.0.0.0', '2023-07-12 22:59:53', '2023-04-13 22:59:53', '811f32abf4041af15e0d8491ee32d5d0b04d2f558de1644537469ce4ba616111', 'sysUser', '2023-03-24 14:40:45', 'sysUser', '2023-05-04 15:29:33', NULL, NULL, '0', NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('33', NULL, 'cs', 'cs', '00', '', '', '0', '', '$2a$10$aQBc2LOJUt.5ca7Vh0nMZuX5kA3KYukeiahlCgK/ptFRHDsM4hdKu', '0', '0', '', NULL, '0.0.0.0', '2023-04-13 22:32:42', '2023-04-13 22:14:44', '685c21f6fe0c0fe616c308d01e1c89d643b184062fb84c8432fc82a0eb6fd25f', 'sysUser', '2023-04-13 20:59:50', 'sysUser', '2023-05-04 15:29:33', NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('34', NULL, 'test', 'test', '00', '', '', '0', '', '$2a$10$qS2ydHpGLty7A2jtOOOS0e5gOGGvEfC3c16CV2THOLGB.i0hEbFb6', '0', '0', '', NULL, '0.0.0.0', '2023-07-12 22:48:17', '2023-04-13 22:48:17', '6ab03f16c83cad774889937360d4ee3a64e1d3c6846325f00373259b7da4579f', 'sysUser', '2023-04-13 22:23:08', 'sysUser', '2023-05-04 15:29:33', NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('35', NULL, 'test1', 'test1', '00', '', '', '0', '', '$2a$10$3e9Sd1ougmCCe6V40FhvGOPwttxhq79d5s2RN7hZS7h/wi17Qwg8W', '0', '0', '', NULL, '0.0.0.0', '2023-04-14 00:00:00', NULL, '0e64166d9757086ba42f1393d6c16d15341c19a0df91fdacb94ab64e770da3aa', 'test', '2023-04-13 23:26:51', 'sysUser', '2023-05-04 15:29:34', NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('36', NULL, 'ywUser1', 'ywUser1', '00', '', '', '0', '', '$2a$10$7OpReX3IPpwFuRvEx.wuUOJlLIiPZi9aolJ4wZ5K64IzYa1UIxQTC', '0', '0', '', NULL, '0.0.0.0', '2023-08-02 15:49:26', '2023-05-04 15:49:26', '78908c16a89c6fb5c72aa725c0a7445751cf9256bbd75ffd9c9774a052290035', 'admin', '2023-05-04 15:38:33', 'ywUser1', '2023-05-04 15:51:48', NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('37', NULL, 'tzyws', 'tzyws', '00', '', '', '0', '', '$2a$10$N7h25F9462pdE4JJkloQ7ODPzy0knBOUkIoLgSljRLyT7Qvve7K9e', '0', '0', '', NULL, '0.0.0.0', '2023-09-05 17:25:00', NULL, NULL, 'admin', '2023-09-05 17:22:06', '', '2023-09-05 17:22:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('8', NULL, '孙奕林', 'syl', '00', '', '', '0', '', '$2a$10$Lv6H6D7PqN0puAubgz1ZleeN.pIbjU2WNMN/U4Qb2eDCZHIrfGC1y', '0', '2', '', NULL, '0.0.0.0', NULL, NULL, NULL, 'admin', '2022-10-25 15:51:51', '', NULL, '看ipcs', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `sys_zruser` (`id`, `uid`, `uname`, `upasswd`, `uy`, `cjsj`, `sjh`, `fwcs`, `yhzt`, `yhlx`, `dxfssj`, `sfcd`, `yxfs`, `syqk`, `column14`, `column15`, `column16`, `column17`, `column18`, `column19`, `column20`, `column21`, `column22`, `column23`, `column24`, `column25`, `column26`, `column27`, `column28`, `column29`, `column30`) VALUES ('9', NULL, 'syl', '孙奕林', '00', '', '', '0', '', '$2a$10$Lv6H6D7PqN0puAubgz1ZleeN.pIbjU2WNMN/U4Qb2eDCZHIrfGC1y', '0', '2', '', NULL, '0.0.0.0', '2023-11-30 00:00:00', NULL, '9857731e6c90caecc8b76a75b8c44878bcd348a1d51eeef1a5623de023ad542f', 'admin', '2022-10-25 15:53:23', 'syl', '2023-03-14 13:18:24', NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_sys_resource
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_resource`;
CREATE TABLE `t_sys_resource` (
  `id` varchar(255) NOT NULL COMMENT '全局唯一编号',
  `name` varchar(64) NOT NULL COMMENT '名称',
  `type` varchar(64) DEFAULT NULL COMMENT '类型',
  `url` varchar(128) DEFAULT NULL COMMENT '唯一标识',
  `addr` varchar(64) DEFAULT NULL COMMENT '地址',
  `tag` varchar(64) DEFAULT NULL COMMENT '特征',
  `desc` varchar(64) DEFAULT NULL COMMENT '描述',
  `remark` varchar(64) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT '1' COMMENT '状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人uuid',
  `update_time` datetime DEFAULT NULL COMMENT '修改日期',
  `update_by` varchar(255) DEFAULT NULL COMMENT '修改人uuid',
  `parent_id` varchar(255) DEFAULT NULL COMMENT '所属租户uuid',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `order` int(11) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `roles` varchar(255) DEFAULT NULL COMMENT '角色（逗号分隔)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='资源表';

-- ----------------------------
-- Records of t_sys_resource
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_sys_role
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role`;
CREATE TABLE `t_sys_role` (
  `id` varchar(255) NOT NULL COMMENT '全局唯一编号',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `type` varchar(255) DEFAULT NULL COMMENT '用户组类型（admin,editor,viewer)',
  `url` varchar(255) DEFAULT NULL COMMENT '唯一标识',
  `addr` varchar(255) DEFAULT NULL COMMENT '地址',
  `tag` varchar(255) DEFAULT NULL COMMENT '特征',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT '1' COMMENT '状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人uuid',
  `update_time` datetime DEFAULT NULL COMMENT '修改日期',
  `update_by` varchar(255) DEFAULT NULL COMMENT '修改人uuid',
  `parent_id` varchar(255) DEFAULT NULL COMMENT '父级编号',
  `owner_id` varchar(255) DEFAULT NULL COMMENT '所属业主',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户组表';

-- ----------------------------
-- Records of t_sys_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_sys_role_resource
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role_resource`;
CREATE TABLE `t_sys_role_resource` (
  `id` varchar(255) NOT NULL COMMENT '全局唯一编号',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `type` varchar(255) DEFAULT NULL COMMENT '类型',
  `url` varchar(255) DEFAULT NULL COMMENT '唯一标识',
  `addr` varchar(255) DEFAULT NULL COMMENT '地址',
  `tag` varchar(255) DEFAULT NULL COMMENT '特征',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT '1' COMMENT '状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人uuid',
  `update_time` datetime DEFAULT NULL COMMENT '修改日期',
  `update_by` varchar(255) DEFAULT NULL COMMENT '修改人uuid',
  `owner_id` varchar(255) DEFAULT NULL COMMENT '所属业主',
  `role_id` varchar(255) NOT NULL COMMENT '角色编号',
  `resource_id` varchar(255) DEFAULT NULL COMMENT '资源编号',
  `app_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户组与资源关联表';

-- ----------------------------
-- Records of t_sys_role_resource
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_role`;
CREATE TABLE `t_sys_user_role` (
  `id` varchar(255) NOT NULL COMMENT '全局唯一编号',
  `name` varchar(64) DEFAULT NULL COMMENT '名称',
  `type` varchar(64) DEFAULT NULL COMMENT '类型',
  `url` varchar(64) DEFAULT NULL COMMENT '唯一标识',
  `addr` varchar(64) DEFAULT NULL COMMENT '地址',
  `tag` varchar(64) DEFAULT NULL COMMENT '特征',
  `desc` varchar(64) DEFAULT NULL COMMENT '描述',
  `remark` varchar(64) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT '1' COMMENT '状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人uuid',
  `update_time` datetime DEFAULT NULL COMMENT '修改日期',
  `update_by` varchar(255) DEFAULT NULL COMMENT '修改人uuid',
  `owner_id` varchar(255) DEFAULT NULL COMMENT '所属租户uuid',
  `user_id` varchar(255) DEFAULT NULL,
  `role_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户关联角色表';

-- ----------------------------
-- Records of t_sys_user_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` varchar(255) NOT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `pass_word` varchar(255) DEFAULT NULL,
  `real_name` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `addr` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `user_name` (`user_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` (`id`, `user_name`, `pass_word`, `real_name`, `role`, `tel`, `remark`, `addr`, `desc`, `tag`, `type`, `url`, `status`, `name`) VALUES ('5a44aab9634ee79c7aa982f67db8ff81', 'xly', '123456Aa', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 0, 'string');
INSERT INTO `t_user` (`id`, `user_name`, `pass_word`, `real_name`, `role`, `tel`, `remark`, `addr`, `desc`, `tag`, `type`, `url`, `status`, `name`) VALUES ('75d2182fc84083f4cb2d077bfa74f181', 'zrkj', '123456Aa', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 0, 'string');
INSERT INTO `t_user` (`id`, `user_name`, `pass_word`, `real_name`, `role`, `tel`, `remark`, `addr`, `desc`, `tag`, `type`, `url`, `status`, `name`) VALUES ('9ec9bfbdc410a7a698049772708fc47f', 'giao', '123456Aa', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 0, 'string');
INSERT INTO `t_user` (`id`, `user_name`, `pass_word`, `real_name`, `role`, `tel`, `remark`, `addr`, `desc`, `tag`, `type`, `url`, `status`, `name`) VALUES ('d5fa4c5a690ee955463d47c1813850bd', 'syl', '123456Aa', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 'string', 0, 'string');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
